package jdbc;

import java.nio.charset.StandardCharsets;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 * 用户登录功能
 * 程序启动后要求输入用户名和密码
 * 然后对比数据库的数据，如果正确则登录成功，否则登录失败
 */
public class LoginDemo {
    public static void main(String[] args) {
        UserInfo userInfo=InputUtil.getInputObject(new UserInfo(),"用户登录","登录");
        System.out.println(userInfo);

        try(
                Connection connection=DBUtil.getConnection();
                ){
            Statement statement=connection.createStatement();

            String sql="SELECT id, username,password,nickname,age FROM userinfo WHERE username='"+userInfo.getUsername()+"' AND password='"+userInfo.getPassword()+"'";
            System.out.println(sql);
            ResultSet rs = statement.executeQuery(sql);

            if(rs.next()){
                int id=rs.getInt("id");
                System.out.println("登录成功！欢迎您："+rs.getString("nickname"));
            }else {
                System.out.println("登录失败！账号或密码错误");
            }



        }catch (Exception e){
            e.printStackTrace();
        }

    }
}
